1 DECLARE @baseSQL
nvarchar(max),
5 SET @baseSQL
= 'ALTER TABLE /*_*/filearchive DROP CONSTRAINT ';--
8 FROM sys.check_constraints cc
10 ON c.object_id
= cc.parent_object_id
11 AND c.column_id
= cc.parent_column_id
13 cc.parent_object_id
= OBJECT_ID('/*_*/filearchive')
14 AND c.
name = 'fa_major_mime';--
16 SET @
SQL = @baseSQL
+ @
id;--
18 EXEC sp_executesql @
SQL;--
21 FROM sys.check_constraints cc
23 ON c.object_id
= cc.parent_object_id
24 AND c.column_id
= cc.parent_column_id
26 cc.parent_object_id
= OBJECT_ID('/*_*/filearchive')
27 AND c.
name = 'fa_media_type';--
29 SET @
SQL = @baseSQL
+ @
id;--
31 EXEC sp_executesql @
SQL;--
33 ALTER TABLE /*_*/filearchive
ADD CONSTRAINT fa_major_mime_ckc
check (fa_major_mime
IN('unknown', 'application', 'audio', 'image', 'text', 'video', 'message', 'model', 'multipart'));--
34 ALTER TABLE /*_*/filearchive
ADD CONSTRAINT fa_media_type_ckc
check (fa_media_type
in('UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO', 'VIDEO', 'MULTIMEDIA', 'OFFICE', 'TEXT', 'EXECUTABLE', 'ARCHIVE'));